1
2 <?php
3 include_once 'header.php';
4 ?>
5 <html>
6 <head>
7 <title>newton</title>
8 <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
9
10 <!-- Optional theme -->
11 <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
12
13 <!-- Latest compiled and minified JavaScript -->
14 <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
15 </head>
16 <style>
17 table,th,td
18 {
19 border: 2px color:transparent;
20 font-family: monospace;
21 font-size: 150%;
22 padding: 0.25cm;
23 background-color: black;
24
25 }
26 body{
27 background-image: url("images/newton1.jpg");
28 -moz-background-size: cover;
29 -webkit-background-size: cover;
30 background-size: cover;
31 background-position: top center !important;
32 background-repeat: no-repeat !important;
33 background-attachment: fixed;
34 color: white;
35 }
36 button
37 {
38 display: block;
39 margin: 0 auto;
40 width: 10%;
41 height: 40px;
42 border: none;
43 background-color: #222;
44 font-family: arial;
45 font-size: 16px;
46 color: #fff;
47 cursor: pointer;
48 }
49 </style>
50
51 <head>
52 <h1 align="middle" style="font-size: 500%;"><u>Newton</u></h1>
53 </head>
54
55
56 <body style="background-color: powderblue; font-family: monospace; margin: 0; padding: 0;">
57 <h1> </h1>
58 <p align=middle>
59 <video width="700" height="545" controls >
60 <source src="video/newton.mp4" type="video/mp4">
61 </video>
62 <h1 align="middle" style="font-size: 300%;"><u><b>Trailer</b></u></h1>
63 </p>
64
65 <br><br><br><br>
66
67 <?php
68 $dbServername = "localhost";
69 $dbUsername = "root";
70 $dbPassword = "password";
71 $dbName = "test";
72
73 $conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
74
75 $sql="SELECT description,genre,mov_lang,dir_name,stars from movie m,director d,rating r where d.dir_id=m.dir_id and r.mov_id=m.mov_id and mov_name='Newton'; ";
76 mysqli_query($conn, $sql) or die('Error');
77 $result = mysqli_query($conn, $sql);
78 while($row=mysqli_fetch_array($result))
79 {
80 echo '<table style="margin-left:20%; margin-right:20%;">
81
82 <tr>
83 <td><u><b> Description</b></u></td>
84 <td>'.$row['description'].'</td>
85 </tr>
86 <tr>
87 <td><u><b> Genre</b></u></td>
88 <td>'.$row['genre'].'</td>
89 </tr>
90 <tr>
91 <td><u> <b>Language</b> </u></td>
92 <td>'.$row['mov_lang'].'</td>
93 </tr>
94 <tr>
95 <td><u><b> Director </b></u></td>
96 <td>'.$row['dir_name'].'</td>
97 </tr>
98 <tr>
99 <td><u><b>Rating </b></u></td>
100 <td>'.$row['stars'].'</td>
101 </tr>
102 </table><br><br><br><br>';
103 }
104 ?>
105
106 <h1 align="middle" style="font-size: 300%;"><u><b>Cast</b></u></h1>
107
108 <?php
109 $sql1="SELECT actor_name,role from actor a,movie m,movie_cast mc where a.actor_id=mc.actor_id and mc.mov_id=m.mov_id and m.mov_name='Newton';";
110 mysqli_query($conn, $sql) or die('Error');
111 $result1 = mysqli_query($conn, $sql1);
112 echo '<br><table style="margin-left: auto; margin-right: auto;">
113 <tr align="middle">
114 <td><u><b>Actor</b></u></td>
115 <td><u><b>Role</b></u></td>
116 </tr>';
117 while($row=mysqli_fetch_array($result1))
118 {
119 echo '<tr>
120 <td>'.$row['actor_name'].'</td>
121 <td align="middle">'.$row['role'].'</td>
122 </tr>';
123 }
124
125 echo '</table><br><br><br>';
126
127 $_SESSION['mov_name']="Newton";
128
129 ?>
130
131 <center><a href="nowshowing.php" class="btn btn-default btn-lg" style="font-size:15px padding-top:0.25%; font-family: comic sans ms; color: black" role="button"><b>Book now</b></a></center><br>
132
133
134 </body>
135 </html>
136
137 <?php
138 include_once 'footer.php';
139 ?>